Use Like criterion to locate data
Use the OR criteria to query on alternate or multiple conditions
Examples of wildcard characters
Compare two tables and find only matching data
Create and run an update query
Delete duplicate records with a query
What do I do if I get an error message about not being able to delete from the specified tables?
Add records to a table by using an append query
Common errors when you run an append query
Use a union query to combine multiple queries into a single result